Pandas Profiling Report

Dataset statistics

Number of variables	41
Number of observations	70372
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	22.0 MiB
Average record size in memory	328.0 B

Variable types

BOOL	29
NUM	9
CAT	3

Warnings

`order_dt` has a high cardinality: 2160 distinct values	High cardinality
`first_order_dt` has a high cardinality: 2931 distinct values	High cardinality
`first_cont_dt` has a high cardinality: 1398 distinct values	High cardinality
`tot_contribution_paid_amt` is highly skewed (γ1 = 69.13668969)	Skewed
`Lifetime Giving` is highly skewed (γ1 = 30.32802605)	Skewed
`tot_ticket_paid_amt` has 34085 (48.4%) zeros	Zeros
`tot_contribution_paid_amt` has 68563 (97.4%) zeros	Zeros
`Prelim Capacity` has 30829 (43.8%) zeros	Zeros
`ltv_tkt_value` has 21484 (30.5%) zeros	Zeros
`Lifetime Giving` has 58829 (83.6%) zeros	Zeros
`days_to_donation` has 1248 (1.8%) zeros	Zeros
`rolling_tkt_sum` has 26312 (37.4%) zeros	Zeros

Reproduction

Analysis started	2020-09-08 17:03:00.404623
Analysis finished	2020-09-08 17:04:58.844874
Duration	1 minute and 58.44 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

owner_no
Real number (ℝ_≥0)

Distinct	38522
Distinct (%)	54.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2022525.081
Minimum	111
Maximum	2419301
Zeros	0
Zeros (%)	0.0%
Memory size	549.8 KiB

Quantile statistics

Minimum	111
5-th percentile	397258.05
Q1	1928112
median	2370216.5
Q3	2391456
95-th percentile	2413551.9
Maximum	2419301
Range	2419190
Interquartile range (IQR)	463344

Descriptive statistics

Standard deviation	629695.9448
Coefficient of variation (CV)	0.3113414765
Kurtosis	2.187826958
Mean	2022525.081
Median Absolute Deviation (MAD)	40994.5
Skewness	-1.835938465
Sum	1.42329135e+11
Variance	3.965169829e+11
Monotocity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2335299	66	0.1%
1485790	64	0.1%
275098	48	0.1%
2289267	47	0.1%
2373627	47	0.1%
2140595	46	0.1%
2133270	44	0.1%
2375331	43	0.1%
2388599	43	0.1%
2387926	42	0.1%
Other values (38512)	69882	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
111	3	< 0.1%
258	1	< 0.1%
262	2	< 0.1%
267	5	< 0.1%
853	3	< 0.1%

Value	Count	Frequency (%)
2419301	1	< 0.1%
2419278	1	< 0.1%
2419248	1	< 0.1%
2419126	1	< 0.1%
2419011	1	< 0.1%

order_dt
Categorical

HIGH CARDINALITY

Distinct	2160
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

2017-08-23	1301
2019-08-14	1024
2015-09-02	919
2016-09-07	822
2014-09-03	796
Other values (2155)	65510

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2017-08-23	1301	1.8%
2019-08-14	1024	1.5%
2015-09-02	919	1.3%
2016-09-07	822	1.2%
2014-09-03	796	1.1%
2018-08-29	713	1.0%
2016-09-23	423	0.6%
2017-09-23	420	0.6%
2017-09-19	387	0.5%
2016-09-27	376	0.5%
Other values (2150)	63191	89.8%

Frequencies of value counts

Unique

Unique	142 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

tot_ticket_paid_amt
Real number (ℝ_≥0)

ZEROS

Distinct	1159
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	107.3262916
Minimum	0
Maximum	5400
Zeros	34085
Zeros (%)	48.4%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	20
Q3	156.6755609
95-th percentile	432
Maximum	5400
Range	5400
Interquartile range (IQR)	156.6755609

Descriptive statistics

Standard deviation	197.7355773
Coefficient of variation (CV)	1.842377802
Kurtosis	64.08996281
Mean	107.3262916
Median Absolute Deviation (MAD)	20
Skewness	5.40552422
Sum	7552765.793
Variance	39099.35852
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	34085	48.4%
40	1032	1.5%
20	953	1.4%
198	793	1.1%
38	761	1.1%
138	714	1.0%
238	695	1.0%
60	675	1.0%
100	659	0.9%
50	633	0.9%
Other values (1149)	29372	41.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34085	48.4%
1	1	< 0.1%
2	4	< 0.1%
3	1	< 0.1%
4	14	< 0.1%

Value	Count	Frequency (%)
5400	1	< 0.1%
5180	1	< 0.1%
4588	1	< 0.1%
4414	1	< 0.1%
4292	1	< 0.1%

tot_contribution_paid_amt
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	131
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.020798045
Minimum	0
Maximum	5000
Zeros	68563
Zeros (%)	97.4%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	5000
Range	5000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	42.71554863
Coefficient of variation (CV)	21.1379602
Kurtosis	6497.137924
Mean	2.020798045
Median Absolute Deviation (MAD)	0
Skewness	69.13668969
Sum	142207.6
Variance	1824.618095
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	68563	97.4%
100	334	0.5%
10	217	0.3%
25	183	0.3%
50	128	0.2%
20	125	0.2%
5	97	0.1%
40	76	0.1%
2	47	0.1%
250	32	< 0.1%
Other values (121)	570	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	68563	97.4%
1	21	< 0.1%
1.5	1	< 0.1%
2	47	0.1%
2.2	3	< 0.1%

Value	Count	Frequency (%)
5000	2	< 0.1%
2500	5	< 0.1%
2250	1	< 0.1%
2000	2	< 0.1%
1500	1	< 0.1%

first_order_dt
Categorical

HIGH CARDINALITY

Distinct	2931
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

2017-08-23	824
2015-09-02	672
2014-09-03	635
2016-09-23	462
2014-09-23	446
Other values (2926)	67333

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2017-08-23	824	1.2%
2015-09-02	672	1.0%
2014-09-03	635	0.9%
2016-09-23	462	0.7%
2014-09-23	446	0.6%
2014-09-26	424	0.6%
2016-09-15	416	0.6%
2016-09-07	410	0.6%
2014-09-22	407	0.6%
2015-09-28	378	0.5%
Other values (2921)	65298	92.8%

Frequencies of value counts

Unique

Unique	281 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

first_cont_dt
Categorical

HIGH CARDINALITY

Distinct	1398
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

1900-01-01	58782
2018-08-06	490
2020-03-26	226
2020-03-30	148
2020-03-25	100
Other values (1393)	10626

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
1900-01-01	58782	83.5%
2018-08-06	490	0.7%
2020-03-26	226	0.3%
2020-03-30	148	0.2%
2020-03-25	100	0.1%
2020-04-24	89	0.1%
2020-05-05	83	0.1%
2020-03-27	81	0.1%
2016-03-30	66	0.1%
2016-09-07	66	0.1%
Other values (1388)	10241	14.6%

Frequencies of value counts

Unique

Unique	298 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

geo_area_desc
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.674103337
Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Memory size	549.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	6
Maximum	7
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.497853338
Coefficient of variation (CV)	0.8947197612
Kurtosis	5.987047599
Mean	1.674103337
Median Absolute Deviation (MAD)	0
Skewness	2.620774255
Sum	117810
Variance	2.243564621
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	51168	72.7%
2	10277	14.6%
7	3473	4.9%
3	2428	3.5%
5	1503	2.1%
4	1080	1.5%
6	443	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	51168	72.7%
2	10277	14.6%
3	2428	3.5%
4	1080	1.5%
5	1503	2.1%

Value	Count	Frequency (%)
7	3473	4.9%
6	443	0.6%
5	1503	2.1%
4	1080	1.5%
3	2428	3.5%

Prelim Capacity
Real number (ℝ_≥0)

ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.910319445
Minimum	0
Maximum	10
Zeros	30829
Zeros (%)	43.8%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	4
95-th percentile	5
Maximum	10
Range	10
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.946138595
Coefficient of variation (CV)	1.018750345
Kurtosis	-1.09127187
Mean	1.910319445
Median Absolute Deviation (MAD)	2
Skewness	0.4400920866
Sum	134433
Variance	3.787455429
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	30829	43.8%
4	11622	16.5%
3	11043	15.7%
2	6672	9.5%
5	5271	7.5%
1	2997	4.3%
6	1611	2.3%
7	181	0.3%
8	130	0.2%
9	13	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	30829	43.8%
1	2997	4.3%
2	6672	9.5%
3	11043	15.7%
4	11622	16.5%

Value	Count	Frequency (%)
10	3	< 0.1%
9	13	< 0.1%
8	130	0.2%
7	181	0.3%
6	1611	2.3%

ltv_tkt_value
Real number (ℝ_≥0)

ZEROS

Distinct	2560
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	793.0981255
Minimum	0
Maximum	42312
Zeros	21484
Zeros (%)	30.5%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	149
Q3	536
95-th percentile	3740
Maximum	42312
Range	42312
Interquartile range (IQR)	536

Descriptive statistics

Standard deviation	2425.538425
Coefficient of variation (CV)	3.058308104
Kurtosis	94.91915165
Mean	793.0981255
Median Absolute Deviation (MAD)	149
Skewness	8.256546927
Sum	55811901.29
Variance	5883236.65
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21484	30.5%
40	782	1.1%
20	758	1.1%
60	564	0.8%
38	500	0.7%
138	492	0.7%
238	476	0.7%
198	464	0.7%
78	452	0.6%
118	430	0.6%
Other values (2550)	43970	62.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	21484	30.5%
2	2	< 0.1%
4	13	< 0.1%
5	7	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
42312	31	< 0.1%
33271	33	< 0.1%
30819	64	0.1%
29997	31	< 0.1%
21131	17	< 0.1%

Lifetime Giving
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	584
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4568.75912
Minimum	0
Maximum	3417602
Zeros	58829
Zeros (%)	83.6%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	490
Maximum	3417602
Range	3417602
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	106920.769
Coefficient of variation (CV)	23.40258399
Kurtosis	951.2318377
Mean	4568.75912
Median Absolute Deviation (MAD)	0
Skewness	30.32802605
Sum	321512716.8
Variance	1.143205085e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	58829	83.6%
100	792	1.1%
25	673	1.0%
10	488	0.7%
50	465	0.7%
20	266	0.4%
200	264	0.4%
5	204	0.3%
250	193	0.3%
40	161	0.2%
Other values (574)	8037	11.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	58829	83.6%
1	38	0.1%
1.25	2	< 0.1%
1.37	4	< 0.1%
2	92	0.1%

Value	Count	Frequency (%)
3417602	64	0.1%
2061042	3	< 0.1%
1042301	31	< 0.1%
461460.08	15	< 0.1%
357601	16	< 0.1%

prospect_board
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	69057
1	1315

Common Values
Chart

Value	Count	Frequency (%)
0	69057	98.1%
1	1315	1.9%

days_to_donation
Real number (ℝ)

ZEROS

Distinct	1172
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	52.23992497
Minimum	-100
Maximum	3747
Zeros	1248
Zeros (%)	1.8%
Memory size	549.8 KiB

Quantile statistics

Minimum	-100
5-th percentile	-100
Q1	-100
median	-100
Q3	-100
95-th percentile	1108
Maximum	3747
Range	3847
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	490.9563657
Coefficient of variation (CV)	9.398106256
Kurtosis	17.90792151
Mean	52.23992497
Median Absolute Deviation (MAD)	0
Skewness	4.0617276
Sum	3676228
Variance	241038.153
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-100	58782	83.5%
0	1248	1.8%
-1	787	1.1%
1506	66	0.1%
177	64	0.1%
1	58	0.1%
153	52	0.1%
604	50	0.1%
109	49	0.1%
807	48	0.1%
Other values (1162)	9168	13.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-100	58782	83.5%
-1	787	1.1%
0	1248	1.8%
1	58	0.1%
2	14	< 0.1%

Value	Count	Frequency (%)
3747	25	< 0.1%
3723	6	< 0.1%
3716	7	< 0.1%
3694	1	< 0.1%
3683	13	< 0.1%

first_cont_order
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	69124
1	1248

Common Values
Chart

Value	Count	Frequency (%)
0	69124	98.2%
1	1248	1.8%

first_cont_after
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	60817
1	9555

Common Values
Chart

Value	Count	Frequency (%)
0	60817	86.4%
1	9555	13.6%

rolling_tkt_sum
Real number (ℝ_≥0)

ZEROS

Distinct	4868
Distinct (%)	6.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	806.984696
Minimum	0
Maximum	153692
Zeros	26312
Zeros (%)	37.4%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	80
Q3	310
95-th percentile	3048.35
Maximum	153692
Range	153692
Interquartile range (IQR)	310

Descriptive statistics

Standard deviation	4194.586959
Coefficient of variation (CV)	5.197851929
Kurtosis	426.3247918
Mean	806.984696
Median Absolute Deviation (MAD)	80
Skewness	17.04718958
Sum	56789127.03
Variance	17594559.75
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26312	37.4%
40	852	1.2%
20	754	1.1%
38	715	1.0%
138	658	0.9%
238	621	0.9%
198	601	0.9%
78	564	0.8%
60	550	0.8%
258	462	0.7%
Other values (4858)	38283	54.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	26312	37.4%
2	3	< 0.1%
4	11	< 0.1%
5	7	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
153692	2	< 0.1%
152920	1	< 0.1%
140320	2	< 0.1%
140080	4	< 0.1%
139980	1	< 0.1%

channel_desc_3rd Party
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	67715
1	2657

Common Values
Chart

Value	Count	Frequency (%)
0	67715	96.2%
1	2657	3.8%

channel_desc_At the Performance
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70169
1	203

Common Values
Chart

Value	Count	Frequency (%)
0	70169	99.7%
1	203	0.3%

channel_desc_Chat
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70178
1	194

Common Values
Chart

Value	Count	Frequency (%)
0	70178	99.7%
1	194	0.3%

channel_desc_Default Channel
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	63212
1	7160

Common Values
Chart

Value	Count	Frequency (%)
0	63212	89.8%
1	7160	10.2%

channel_desc_Email
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	68361
1	2011

Common Values
Chart

Value	Count	Frequency (%)
0	68361	97.1%
1	2011	2.9%

channel_desc_Fax
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70358
1	14

Common Values
Chart

Value	Count	Frequency (%)
0	70358	> 99.9%
1	14	< 0.1%

channel_desc_Internal Request
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	64861
1	5511

Common Values
Chart

Value	Count	Frequency (%)
0	64861	92.2%
1	5511	7.8%

channel_desc_Mail
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70039
1	333

Common Values
Chart

Value	Count	Frequency (%)
0	70039	99.5%
1	333	0.5%

channel_desc_Mobile
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	62036
1	8336

Common Values
Chart

Value	Count	Frequency (%)
0	62036	88.2%
1	8336	11.8%

channel_desc_Online
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

1	35256
0	35116

Common Values
Chart

Value	Count	Frequency (%)
1	35256	50.1%
0	35116	49.9%

channel_desc_Phone
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	61875
1	8497

Common Values
Chart

Value	Count	Frequency (%)
0	61875	87.9%
1	8497	12.1%

channel_desc_Telefunding
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70371
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	70371	> 99.9%
1	1	< 0.1%

channel_desc_Walk Up
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	69808
1	564

Common Values
Chart

Value	Count	Frequency (%)
0	69808	99.2%
1	564	0.8%

MOS_desc_External
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	59247
1	11125

Common Values
Chart

Value	Count	Frequency (%)
0	59247	84.2%
1	11125	15.8%

MOS_desc_Internal
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

1	41201
0	29171

Common Values
Chart

Value	Count	Frequency (%)
1	41201	58.5%
0	29171	41.5%

MOS_desc_Ticketing
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	52118
1	18254

Common Values
Chart

Value	Count	Frequency (%)
0	52118	74.1%
1	18254	25.9%

delivery_desc_Digital
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

1	43240
0	27132

Common Values
Chart

Value	Count	Frequency (%)
1	43240	61.4%
0	27132	38.6%

delivery_desc_Do Not Print Tickets
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	69424
1	948

Common Values
Chart

Value	Count	Frequency (%)
0	69424	98.7%
1	948	1.3%

delivery_desc_Mail
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	59870
1	10502

Common Values
Chart

Value	Count	Frequency (%)
0	59870	85.1%
1	10502	14.9%

delivery_desc_Will Call
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	54426
1	15946

Common Values
Chart

Value	Count	Frequency (%)
0	54426	77.3%
1	15946	22.7%

facility_desc_Academy of Music
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

1	38198
0	32174

Common Values
Chart

Value	Count	Frequency (%)
1	38198	54.3%
0	32174	45.7%

facility_desc_Fundraiser
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	68456
1	1916

Common Values
Chart

Value	Count	Frequency (%)
0	68456	97.3%
1	1916	2.7%

facility_desc_Independence Mall
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	48723
1	21649

Common Values
Chart

Value	Count	Frequency (%)
0	48723	69.2%
1	21649	30.8%

facility_desc_Other
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	68507
1	1865

Common Values
Chart

Value	Count	Frequency (%)
0	68507	97.3%
1	1865	2.7%

facility_desc_Perelman
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	62351
1	8021

Common Values
Chart

Value	Count	Frequency (%)
0	62351	88.6%
1	8021	11.4%

facility_desc_Small venue
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	66278
1	4094

Common Values
Chart

Value	Count	Frequency (%)
0	66278	94.2%
1	4094	5.8%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	owner_no	order_dt	tot_ticket_paid_amt	first_order_dt	first_cont_dt	geo_area_desc	Prelim Capacity	ltv_tkt_value	days_to_donation	rolling_tkt_sum	channel_desc_3rd Party	channel_desc_Default Channel	channel_desc_Internal Request	channel_desc_Online	channel_desc_Phone	MOS_desc_External	MOS_desc_Internal	MOS_desc_Ticketing	delivery_desc_Digital	delivery_desc_Mail	delivery_desc_Will Call	facility_desc_Academy of Music	facility_desc_Fundraiser	facility_desc_Small venue
0	111	2015-10-07	138.0	2015-10-07	1900-01-01	1	5	366.0	-100	138.0	0	1	0	0	0	1	0	0	0	0	1	1	0	0
1	111	2016-09-16	158.0	2015-10-07	1900-01-01	1	5	366.0	-100	296.0	0	0	0	0	1	0	0	1	0	0	1	1	0	0
2	111	2018-09-21	70.0	2015-10-07	1900-01-01	1	5	366.0	-100	366.0	1	0	0	0	0	1	0	0	0	0	1	1	0	0
3	258	2014-09-28	169.0	2014-09-28	1900-01-01	5	6	169.0	-100	169.0	0	1	0	0	0	1	0	0	0	0	1	1	0	0
4	262	2014-10-02	45.0	2014-10-02	1900-01-01	2	4	90.0	-100	135.0	0	0	0	0	1	0	0	1	0	0	1	1	0	0
5	262	2015-03-17	45.0	2014-10-02	1900-01-01	2	4	90.0	-100	270.0	0	0	0	0	1	0	0	1	0	1	0	1	0	0
6	267	2015-04-16	0.0	2015-04-16	1900-01-01	1	6	1778.0	-100	0.0	0	0	1	0	0	0	0	1	0	0	1	1	0	0
7	267	2016-04-13	298.0	2015-04-16	1900-01-01	1	6	1778.0	-100	298.0	0	0	0	1	0	0	1	0	0	1	0	1	0	0
8	267	2016-05-03	0.0	2015-04-16	1900-01-01	1	6	1778.0	-100	0.0	0	0	1	0	0	0	0	1	0	0	1	0	1	0
9	267	2018-05-09	1400.0	2015-04-16	1900-01-01	1	6	1778.0	-100	1698.0	0	0	0	1	0	0	1	0	1	0	0	0	0	1

Last rows

	owner_no	order_dt	tot_ticket_paid_amt	tot_contribution_paid_amt	first_order_dt	first_cont_dt	geo_area_desc	Prelim Capacity	ltv_tkt_value	Lifetime Giving	days_to_donation	first_cont_order	first_cont_after	rolling_tkt_sum	channel_desc_Default Channel	channel_desc_Internal Request	channel_desc_Online	channel_desc_Phone	MOS_desc_External	MOS_desc_Internal	MOS_desc_Ticketing	delivery_desc_Digital	delivery_desc_Mail	delivery_desc_Will Call	facility_desc_Academy of Music	facility_desc_Fundraiser	facility_desc_Independence Mall	facility_desc_Perelman
70362	2418866	2016-02-08	90.0	0.0	2012-10-04	2020-04-20	7	1	90.0	25.0	2755	0	1	90.0	0	0	1	0	0	1	0	1	0	0	1	0	0	0
70363	2418866	2016-02-12	0.0	0.0	2012-10-04	2020-04-20	7	1	90.0	25.0	2755	0	1	0.0	0	1	0	0	0	0	1	0	0	1	0	1	0	0
70364	2418931	2018-04-25	240.0	0.0	2018-04-25	2020-05-05	2	5	240.0	100.0	741	0	1	240.0	0	0	1	0	0	1	0	1	0	0	1	0	0	0
70365	2418999	2016-10-01	0.0	20.0	2016-10-01	2016-10-01	1	3	124.0	20.0	0	1	0	0.0	0	0	1	0	0	1	0	1	0	0	0	0	1	0
70366	2418999	2017-02-13	124.0	0.0	2016-10-01	2016-10-01	1	3	124.0	20.0	0	1	0	124.0	0	0	1	0	0	1	0	1	0	0	1	0	0	0
70367	2419011	2018-09-07	0.0	25.0	2018-09-07	2018-09-07	2	5	0.0	50.0	0	1	0	0.0	0	0	1	0	0	1	0	1	0	0	0	0	1	0
70368	2419126	2019-09-19	0.0	0.0	2019-09-19	1900-01-01	1	0	600.0	0.0	-100	0	0	0.0	0	1	0	0	0	0	1	0	0	1	1	0	0	0
70369	2419248	2017-09-20	440.0	0.0	2017-09-20	2019-12-11	2	4	440.0	100.0	812	0	1	440.0	0	0	0	1	0	0	1	1	0	0	1	0	0	0
70370	2419278	2015-04-13	395.0	0.0	2011-04-03	2003-03-26	1	3	752.0	75.0	-1	0	0	395.0	1	0	0	0	1	0	0	0	1	0	1	0	0	0
70371	2419301	2018-01-18	120.0	0.0	2018-01-18	1900-01-01	1	0	120.0	0.0	-100	0	0	120.0	0	0	1	0	0	1	0	0	1	0	0	0	0	1

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows